//
//  DBManager.h
//  TestDatabase
//
//  Created by a1 technology on 5/28/09.
//  Copyright 2009 __MyCompanyName__. All rights reserved.
//

#import <Foundation/Foundation.h>
#import <sqlite3.h>


@interface DBManager : NSObject {
	NSString *resourceDBPath;
	NSString *docDBpath;
	sqlite3 *database;
	NSString *databaseName;
	//NSMutableArray *queryResult;
}

@property (nonatomic, retain) NSString *resourceDBPath;
@property (nonatomic, retain) NSString *docDBpath;
@property (nonatomic, retain) NSString *databaseName;
+(DBManager *)sharedManager;
-(id)init;
-(BOOL)openDatabaseNamed:(NSString *)newDBName;
-(BOOL)executeOutputQuery:(NSString *)query;
-(BOOL)executeInputQuery:(NSString *)query;
-(void)closeDB;
-(NSArray *)queryResult;
-(void)dealloc;
-(NSArray *)simplifiedQueryData;
-(NSArray *)processedDataAtRow:(int)rowNo ;
-(NSDictionary *)processedDataAtRow:(int)rowNo column:(int)colNo;
@end
